<%@ page language="java" contentType="text/html; charset=UTF-8"
		 pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<html>
<head>
	<title>AEP</title>
	<link rel="stylesheet" href="css/manage.css" type="text/css">
	<link rel="stylesheet" href="css/bootstrap.min.css" type="text/css">
	<link rel="stylesheet" type="text/css" href="css/swiper-4.2.0.min.css">
	<link rel="stylesheet" href="css/footer.css" type="text/css">
	<link rel="stylesheet" href="css/top.css" type="text/css">
	<link rel="stylesheet" href="css/style.css" type="text/css">
</head>
<body>
<%@ include file="module/top.jsp" %>
<div class="row">
	<div class="bodyCon">

			<div id="banner">

				<img src="image/banner.jpg" class="imgItems">

			</div>
	</div>
	<div class="brandText">
		<h1>AEP商情检测</h1>
		<h3>这是一个面向商会管理者、商铺租赁者、战略合作者和政府单位的商业行情检测系统</h3>
		<h3 class="h">我们用数据和图表说话，给你最直观的体验</h3>
	</div>
</div>
<div class="row">
	<div class="containerCon">
		<div class="row">
			<div class="prosperityIndexCon col-lg-12 col-md-12 col-sm-12">
				<h1>景气指数</h1>
				<div class="row">
					<ul class="prosperityIndex col-lg-6 col-md-6 col-sm-6">
						<li>景气指数，亦称景气度，是对企业景气调查中的定性指标通过定量方法加工汇总，综合反映某一特定调查群体或某一社会现象所处的状态或发展趋势的一种指标；</li>
						<li>景气指数介于0-200之间，100为景气指数的临界值；</li>
						<li>当景气指数大于100时，表明经济状况趋于上升或改善，当景气指数小于100时，表明经济状况趋于下降或恶化，处于不景气状态；</li>
						<li>本站点将景气指数反映到几个指数指标上，即：创新指标，环境指标，人力指标，物流指标，租赁指标。</li>
					</ul>
					<div class="col-lg-4 col-md-4 col-sm-4">
						<img src="image/9.jpg" class="prosperityIndexPic">
					</div>
				</div>
				<div class="deFloat"></div>
			</div>
		</div>
		<div class="row">
			<div class="innovationIndexCon col-lg-12 col-md-12">
				<h1>创新指标</h1>
				<div class="row">
					<ul class="innovationIndex col-lg-6 col-md-6">
						<li>创新指标，反映企业在创新价值实现、增强市场竞争力和推动经济发展方式转变方面的能力；</li>
						<li>本站以3个二级指标体现：商铺注册商标数量、电商数量变化趋势、各行业定制化商品平均比率；</li>
						<li>您可以通过对比这三个二级指标，了解到商会所在区域的商铺创新化程度，以便于制定您所需的计划。</li>
					</ul>
					<div class="show-chart col-lg-4 col-md-4">
						<canvas id="pie"></canvas>
					</div>
				</div>
				<div class="deFloat"></div>
			</div>
		</div>
		<div class="row">
			<div class="environmentIndexCon col-lg-12 col-md-12">
				<h1>环境指标</h1>
				<div class="row">
					<ul class="innovationIndex col-lg-6 col-md-6">
						<li>环境指标是为评价商会所在的环境质量而针对环境要素设定的衡量标准；</li>
						<li>本站以3个二级指标体现：保安人数，人流量，餐厅翻台率；</li>
						<li>您可以通过对比这三个二级指标，了解到商会所在区域的商铺环境条件，以便于制定您所需的计划。</li>
					</ul>
					<div class="show-chart col-lg-4 col-md-4">
						<canvas id="spie"></canvas>
					</div>
				</div>
				<div class="deFloat"></div>
			</div>
		</div>
		<div class="row">
			<div class="humanIndexCon col-lg-12 col-md-12">
				<h1>人力指标</h1>
				<div class="row">
					<ul class="innovationIndex col-lg-6 col-md-6">
						<li>人力指标，其重点在于探求现有的人力资源数量是否与企业机构的业务量相匹配，也就是检查现有的人力资源配量是否符合一个机构在一定业务量内的标准人力资源配置。</li>
						<li>本站以3个二级指标体现：薪酬平均数，雇员教育水平占比，雇员平均数；</li>
						<li>您可以通过对比这三个二级指标，了解到商会所在区域的商铺人力资源水平程度，以便于制定您所需的计划。</li>
					</ul>
					<div class="show-chart col-lg-4 col-md-4">
						<canvas id="Polart"></canvas>
					</div>
				</div>
				<div class="deFloat"></div>
			</div>
		</div>
		<div class="row">
			<div class="logisticsIndexCon col-lg-12 col-md-12">
				<h1>物流指标</h1>
				<div class="row">
					<ul class="innovationIndex col-lg-6 col-md-6">
						<li>物流指标，用来衡量物流质量的主要指标，即“目标质量”的具体构成内容；</li>
						<li>本站以4个二级指标体现：开单数，客单价，发货量，发货单数；</li>
						<li>您可以通过对比这四个二级指标，了解到商会所在区域的商铺物流量大小，以便于制定您所需的计划。</li>
					</ul>
					<div class="show-chart col-lg-4 col-md-4">
						<canvas id="ypie"></canvas>
					</div>
				</div>
				<div class="deFloat"></div>
			</div>
		</div>
		<div class="row">
			<div class="leaseholdIndexCon col-lg-12 col-md-12">
				<h1>租赁指标</h1>
				<div class="row">
					<ul class="innovationIndex col-lg-6 col-md-6">
						<li>租赁指标，是指出租人向承租人提供的一系列价格标准；</li>
						<li>本站以4个二级指标体现：租金，入驻率，商铺管理费，商铺转手费；</li>
						<li>您可以通过对比这四个二级指标，了解到商会所在区域的商铺店面各系列资金，以便于制定您所需的计划。</li>
					</ul>
					<div class="show-chart col-lg-4 col-md-4">
						<canvas id="sPolar"></canvas>
					</div>
				</div>
				<div class="deFloat"></div>
			</div>
		</div>
	</div>
</div>
<!-- Footer -->
<div class="footer row">
	<!-- Copyright -->
	<div class="copyright">

		<div class="footLeft  col-lg-4 col-md-4 col-sm-4">
			<h4>联系我们</h4>
			<h5>广东省广州市海珠区AEP街道666号</h5>
			<h5>tel：666 6666 6666</h5>
			<h5>fax：666 6666 6666</h5>
			<h5>e-mail：AEP@666666.com</h5>
		</div>
		<div class="footMiddle col-lg-4 col-md-4 col-sm-4">
			<h4>关注我们</h4>
			<img src="image/follow1.PNG" class="followPic">
			<img src="image/follow2.PNG" class="followPic">
			<img src="image/follow3.PNG" class="followPic">
			<img src="image/follow4.PNG" class="followPic">
			<h5>
				&copy; 2018. All Rights Reserved | Design by<a href="120.77.252.208/blog">M</a>
			</h5>
		</div>
		<div class="footRight col-lg-4 col-md-4 col-sm-4">
			<h4>本站建议</h4>
			<h5>建议用户使用IE9+、FireFox、Google Chrome，分辨率1280*800及以上浏览本网站。</h5>
		</div>
	</div>
	<!-- //Copyright -->
</div>
<%
	//驱动程序名
	String driverName = "com.mysql.jdbc.Driver";
	//数据库用户名
	String userName = "root";
	//密码
	String userPasswd = "";
	//数据库名
	String dbName = "detecting_system";
	//表名
	String tableName = "market_index";
	//联结字符串
	String url = "jdbc:mysql://localhost:3306/" + dbName + "?user="
			+ userName + "&password=" + userPasswd;
	Class.forName("com.mysql.jdbc.Driver").newInstance();
	Connection connection = DriverManager.getConnection(url);
	Statement statement = connection.createStatement();
	String sql = "SELECT * FROM " + tableName;
	ResultSet rs = statement.executeQuery(sql);
	Object user_id = session.getAttribute("user_id");
	String sqls = " select * from market_index where market_id in (select market_id from market_management where user_id=" + user_id + ")";
%>
<%
	rs = statement.executeQuery(sqls);
	String[] month_index=new String[20];
	String[] innovation_index=new String[20];
	String[] environmental_index=new String[20];
	String[] fastBatch_index=new String[20];
	String[] logistics_index=new String[20];
	String[] leasehold_index=new String[20];
	String[] human_index=new String[20];
	int i=1;
	while(rs.next())
	{
			month_index[i] = rs.getString(3);
			innovation_index[i] = rs.getString(4);
			environmental_index[i] = rs.getString(5);
			fastBatch_index[i] = rs.getString(6);
			logistics_index[i] = rs.getString(7);
			leasehold_index[i] = rs.getString(8);
			human_index[i] = rs.getString(9);
			i++;
	}
	rs.close();
	statement.close();
	connection.close();

%>
<script src="js/jquery-1.11.2.min.js" type="text/javascript"></script>
<script src="js/bootstrap.js" type="text/javascript"></script>
<script src="js/Chart.min.js"></script>
<script type="text/javascript" src="js/swiper-4.2.0.min.js"></script>
<%--<script type="text/javascript">
    var mySwiper = new Swiper ('.swiper-container', {
        direction: 'horizontal',/*轮播方向*/
        loop: true,/*循环*/

        // 如果需要分页器
        pagination: {
            el: '.swiper-pagination',
        },
        autoplay:true,
        delay: 3000,

    })
</script>--%>
<script>
    /* 创新指标 */
    var piectx = document.getElementById("pie");
    var Chartt = new Chart(piectx,{
        type: 'line',
        data: {
            labels: ["2017-01", "2017-02",  "2017-03","2017-04","2017-05","2017-06","2017-07","2017-08","2017-09","2017-10","2017-11","2017-12"],
            datasets: [{
                label: '创新指标',
                data: [<%=innovation_index[1] %>,<%=innovation_index[2] %>,<%=innovation_index[3] %>,<%=innovation_index[4] %>,<%=innovation_index[5] %>,<%=innovation_index[6] %>,<%=innovation_index[7] %>,<%=innovation_index[8] %>,<%=innovation_index[9] %>,<%=innovation_index[10] %>,<%=innovation_index[11] %>,<%=innovation_index[12] %>],
                backgroundColor: [
                    'rgba(255, 99, 132, 0.8)'
                ],
                borderColor: [
                    'rgba(255,99,132,1)'
                ],
                borderWidth: 1
            }]
        },
        options: {
            title: {
                display: true
            }
        }
    });
    /* 环境指标 */
    var spiectx = document.getElementById("spie");
    var spChart = new Chart(spiectx,{
        type: 'pie',
        data: {
            labels: ["2017-01", "2017-02",  "2017-03","2017-04","2017-05","2017-06","2017-07","2017-08","2017-09","2017-10","2017-11","2017-12"],
            datasets: [{
                label: '环境指标',
                data: [<%=environmental_index[1] %>,<%=environmental_index[2] %>,<%=environmental_index[3] %>,<%=environmental_index[4] %>,<%=environmental_index[5] %>,<%=environmental_index[6] %>,<%=environmental_index[7] %>,<%=environmental_index[8] %>,<%=environmental_index[9] %>,<%=environmental_index[10] %>,<%=environmental_index[11] %>,<%=environmental_index[12] %>],
                backgroundColor: [
                    'rgba(205, 99, 132, 0.8)',
                    'rgba(54, 162, 235, 0.8)',
                    'rgba(95, 56, 86, 0.8)',
                    'rgba(125, 206, 96, 0.8)',
                    'rgba(155, 216, 76, 0.8)',
                    'rgba(85, 116, 106, 0.8)',
                    'rgba(255, 226, 66, 0.8)',
                    'rgba(255, 86, 76, 0.8)',
                    'rgba(75, 206, 26, 0.8)',
                    'rgba(207, 231, 76, 0.8)',
                    'rgba(15, 36, 26, 0.8)',
                    'rgba(235, 46, 56, 0.8)'
                ],
                borderColor: [
                    'rgba(255, 99, 132, 1)',
                    'rgba(54, 162, 235, 1)',
                    'rgba(95, 56, 86, 1)',
                    'rgba(65, 256, 36, 1)',
                    'rgba(155, 216, 76, 1)',
                    'rgba(55, 246, 36, 1)',
                    'rgba(255, 226, 66, 1)',
                    'rgba(255, 86, 76, 1)',
                    'rgba(75, 206, 26, 1)',
                    'rgba(255, 256, 16,1)',
                    'rgba(255, 76, 86, 1)',
                    'rgba(255, 46, 46, 1)'
                ],
                borderWidth: 1
            }]
        },
        options: {
            title: {
                display: true
            }
        }
    });
    /* 租赁指标 */
    var Radarctxs = document.getElementById("sPolar");
    var Chartt1 = new Chart(Radarctxs, {
        type: 'bar',
        data: {
            labels: ["2017-01", "2017-02",  "2017-03","2017-04","2017-05","2017-06","2017-07","2017-08","2017-09","2017-10","2017-11","2017-12"],
            datasets: [{
                label: '租赁指标',
                data: [<%=leasehold_index[1] %>,<%=leasehold_index[2] %>,<%=leasehold_index[3] %>,<%=leasehold_index[4] %>,<%=leasehold_index[5] %>,<%=leasehold_index[6] %>,<%=leasehold_index[7] %>,<%=leasehold_index[8] %>,<%=leasehold_index[9] %>,<%=leasehold_index[10] %>,<%=leasehold_index[11] %>,<%=leasehold_index[12] %>],
                backgroundColor: [
                    'rgba(205, 99, 132, 0.8)',
                    'rgba(54, 162, 235, 0.8)',
                    'rgba(95, 56, 86, 0.8)',
                    'rgba(125, 206, 96, 0.8)',
                    'rgba(155, 216, 76, 0.8)',
                    'rgba(85, 116, 106, 0.8)',
                    'rgba(255, 226, 66, 0.8)',
                    'rgba(255, 86, 76, 0.8)',
                    'rgba(75, 206, 26, 0.8)',
                    'rgba(207, 231, 76, 0.8)',
                    'rgba(15, 36, 26, 0.8)',
                    'rgba(235, 46, 56, 0.8)'
                ],
                borderColor: [
                    'rgba(255, 99, 132, 1)',
                    'rgba(54, 162, 235, 1)',
                    'rgba(95, 56, 86, 1)',
                    'rgba(65, 256, 36, 1)',
                    'rgba(155, 216, 76, 1)',
                    'rgba(55, 246, 36, 1)',
                    'rgba(255, 226, 66, 1)',
                    'rgba(255, 86, 76, 1)',
                    'rgba(75, 206, 26, 1)',
                    'rgba(255, 256, 16,1)',
                    'rgba(255, 76, 86, 1)',
                    'rgba(255, 46, 46, 1)'
                ],
                borderWidth: 1
            }]
        },
        options: {
            title: {
                display: true
            }
        }
    });

    /* 物流指标 */
    var tRadarctx = document.getElementById("ypie");
    var tChart = new Chart(tRadarctx, {
        type: 'doughnut',
        data: {
            labels: ["2017-01", "2017-02",  "2017-03","2017-04","2017-05","2017-06","2017-07","2017-08","2017-09","2017-10","2017-11","2017-12"],
            datasets: [{
                label: '物流指标',
                data: [<%=logistics_index[1] %>,<%=logistics_index[2] %>,<%=logistics_index[3] %>,<%=logistics_index[4] %>,<%=logistics_index[5] %>,<%=logistics_index[6] %>,<%=logistics_index[7] %>,<%=logistics_index[8] %>,<%=logistics_index[9] %>,<%=logistics_index[10] %>,<%=logistics_index[11] %>,<%=logistics_index[12] %>],
                backgroundColor: [
                    'rgba(205, 99, 132, 0.8)',
                    'rgba(54, 162, 235, 0.8)',
                    'rgba(95, 56, 86, 0.8)',
                    'rgba(125, 206, 96, 0.8)',
                    'rgba(155, 216, 76, 0.8)',
                    'rgba(85, 116, 106, 0.8)',
                    'rgba(255, 226, 66, 0.8)',
                    'rgba(255, 86, 76, 0.8)',
                    'rgba(75, 206, 26, 0.8)',
                    'rgba(207, 231, 76, 0.8)',
                    'rgba(15, 36, 26, 0.8)',
                    'rgba(235, 46, 56, 0.8)'
                ],
                borderColor: [
                    'rgba(255, 99, 132, 1)',
                    'rgba(54, 162, 235, 1)',
                    'rgba(95, 56, 86, 1)',
                    'rgba(65, 256, 36, 1)',
                    'rgba(155, 216, 76, 1)',
                    'rgba(55, 246, 36, 1)',
                    'rgba(255, 226, 66, 1)',
                    'rgba(255, 86, 76, 1)',
                    'rgba(75, 206, 26, 1)',
                    'rgba(255, 256, 16,1)',
                    'rgba(255, 76, 86, 1)',
                    'rgba(255, 46, 46, 1)'
                ],
                borderWidth: 1
            }]
        },
        options: {
            title: {
                display: true
            }
        }
    });


    /* 人力指标 */
    var Radarctx = document.getElementById("Polart");
    var yChart = new Chart(Radarctx, {
        type: 'radar',
        data: {
            labels: ["2017-01", "2017-02",  "2017-03","2017-04","2017-05","2017-06","2017-07","2017-08","2017-09","2017-10","2017-11","2017-12"],
            datasets: [{
                label: '人力指标',
                data: [<%=human_index[1] %>,<%=human_index[2] %>,<%=human_index[3] %>,<%=human_index[4] %>,<%=human_index[5] %>,<%=human_index[6] %>,<%=human_index[7] %>,<%=human_index[8] %>,<%=human_index[9] %>,<%=human_index[10] %>,<%=human_index[11] %>,<%=human_index[12] %>],
                backgroundColor: [

                    'rgba(74, 162, 235, 0.8)'

                ],
                borderColor: [
                    'rgba(255, 99, 132, 1)'

                ],
                borderWidth: 1
            }]
        },
        options: {
            title: {
                display: true
            }
        }
    });
</script>
</body>
</html>